Skip to main content

Commit Transaction

AutomatR.OracleDB.Database.CommitTransaction

The "Commit Transaction" activity in AutomatR for Oracle databases finalizes and commits the ongoing transaction. This activity is essential for ensuring that all changes made within the transaction are permanently saved to the database. If the transaction is successful, the changes are committed; otherwise, they are rolled back.

Properties​

NameDescription
Misc
Display NameProvides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name.
Optional
DelaySpecifies the amount of time (in seconds) to wait before executing the "Commit Transaction" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1.

How to use:

  1. Drag and drop the "Commit Transaction" activity onto the workflow.
  2. Configure the properties by specifying the delay duration.
  3. Place the "Commit Transaction" activity after the database operations you want to include in the transaction.
  4. Execute the workflow to commit the transaction and permanently save the changes made within it to the database.

Note:

  • Use the "Commit Transaction" activity after completing a set of database operations within a transaction to make the changes permanent.
  • Ensure that the "Commit Transaction" activity is used in conjunction with the "Start Transaction" activity to finalize and commit the entire transaction.

Example: Consider an example where the "Commit Transaction" activity is used to commit changes made within a transaction:

Start Transaction:
  Display Name: "Transaction Scope"
  Connection: oracleConnectionVariable

  Sequence:
    OracleDB Activity 1
    OracleDB Activity 2
    OracleDB Activity 3
    Commit Transaction:
      Delay: 2 seconds

In this example, the "Start Transaction" activity begins a transaction, and three database activities (Activity 1, Activity 2, and Activity 3) are executed within the transaction. The "Commit Transaction" activity is used to commit the changes made within the transaction after the database activities. The delay ensures a pause before committing the transaction.